﻿using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace DongFangGuoKai.WMSPlatform.Domain.Models
{
    ///<summary>
    ///库存表
    ///</summary>
    [SugarTable("DBO.t_Inventory")]
    public partial class t_Inventory
    {
        public t_Inventory()
        {


        }
        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:False
        /// </summary>           
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int Id { get; set; }

        /// <summary>
        /// Desc:库房Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? WarehouseId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? WarehouseCode { get; set; }

        /// <summary>
        /// Desc:库房名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? WarehouseName { get; set; }

        /// <summary>
        /// Desc:库区Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? AreaId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? AreaCode { get; set; }

        /// <summary>
        /// Desc:库区名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? AreaName { get; set; }

        /// <summary>
        /// Desc:仓位Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? LocationId { get; set; }

        /// <summary>
        /// Desc:仓位编码
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? LocationCode { get; set; }

        /// <summary>
        /// Desc:垛所在仓位深度
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int LocationDepth { get; set; }

        /// <summary>
        /// Desc:排号
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int LocationLineNO { get; set; }

        /// <summary>
        /// Desc:层号
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int LocationLayerNO { get; set; }

        /// <summary>
        /// Desc:列号
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int LocationColumnNO { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? LocationName { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? LocationHeightType { get; set; }

        /// <summary>
        /// Desc:库存状态：1-正常库存；2-转移中的库存；3-入库在途；4-出库在途；5-限制使用的库存;6-异常库存;7-预分配库存;8-冻结库存;9-输送线在途
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public int? Status { get; set; }

        /// <summary>
        /// Desc:垛条码
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? PalletBarcode { get; set; }

        /// <summary>
        /// Desc:关联详情单Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? RelatedOrderDetailId { get; set; }

        /// <summary>
        /// Desc:单据类型Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? BillType { get; set; }

        /// <summary>
        /// Desc:是否锁定：false-未锁定；true-锁定
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public bool? IsLock { get; set; }

        /// <summary>
        /// Desc:备注
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? Remark { get; set; }

        /// <summary>
        /// Desc:创建时间
        /// Default:DateTime.Now
        /// Nullable:True
        /// </summary>           
        public DateTime? CreateDate { get; set; }

        /// <summary>
        /// Desc:物料Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public long? MaterialId { get; set; }

        /// <summary>
        /// Desc:物料号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? MaterialCode { get; set; }

        /// <summary>
        /// Desc:物料名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? MaterialName { get; set; }

        /// <summary>
        /// Desc:是否有货号详情
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public bool HasSkuDetail { get; set; }

        /// <summary>
        /// Desc:可用库存数量
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public decimal? AvailableQTY { get; set; }

        /// <summary>
        /// Desc:已分配数量
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public decimal? AllocateQTY { get; set; }

        /// <summary>
        /// Desc:上架数量
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public decimal? PutawayQTY { get; set; }

        /// <summary>
        /// Desc:下架数量
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public decimal? PickedQTY { get; set; }

        /// <summary>
        /// Desc:基本单位Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? UnitId { get; set; }

        /// <summary>
        /// Desc:基本单位
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? UnitName { get; set; }

        /// <summary>
        /// Desc:包装数量
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public int? PackQTY { get; set; }

        /// <summary>
        /// Desc:物料批次信息Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? MaterialKeyId { get; set; }

        /// <summary>
        /// Desc:入库时间
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? InStockDate { get; set; }

        /// <summary>
        /// Desc:质量状态：0-待检；1-合格；2-不合格；
        /// Default:1
        /// Nullable:True
        /// </summary>           
        public int? QualityState { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? BatchNO { get; set; }

        /// <summary>
        /// Desc:货主Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? OwnerId { get; set; }

        /// <summary>
        /// Desc:货主
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? OwnerName { get; set; }

        /// <summary>
        /// Desc:有效时间
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? ExpireDate { get; set; }

        /// <summary>
        /// Desc:生产日期
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? ProductDate { get; set; }

        /// <summary>
        /// Desc:供应商Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? SupplierId { get; set; }

        /// <summary>
        /// Desc:供应商
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? SupplierName { get; set; }

        /// <summary>
        /// Desc:物料类型Id
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? MaterialTypeId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? MaterialTypeCode { get; set; }

        /// <summary>
        /// Desc:物料类型
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? MaterialTypeName { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? ProduceFactory { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? OutFactoryDate { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? QADate { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? ERPLocationCode { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? RoutewayId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? StackingStorageId { get; set; }

        /// <summary>
        /// Desc:部门编码
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? DeptCode { get; set; }

        /// <summary>
        /// Desc:部门名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? DeptName { get; set; }

        /// <summary>
        /// Desc:当前业务类型
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int BusinessType { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public decimal? LocationDistanceValue { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? LogicalPartCode { get; set; }

        /// <summary>
        /// Desc:垛实际高度类型
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? RealHeightType { get; set; }

        /// <summary>
        /// Desc:发货单号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? DisOrderNO { get; set; }

        /// <summary>
        /// Desc:发货单行号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? DisOrderLineNO { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? InStockShortDate { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? WoodPalletBarcode { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? PurOrderNO { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? PurOrderLineNO { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? PurOrderLineType { get; set; }

        /// <summary>
        /// Desc:
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public bool? IsMultPallet { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? MultPalletId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public decimal? TotalPrice { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? MaterialCategoryId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? MaterialCategoryName { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? CreateUserId { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? CreateUserName { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? BatchNoExplain { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public decimal? Price { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string? ParentPalletBarcode { get; set; }

    }
}
